I have to search in database some name. If I write
LIKE '%Alex Maxim%' - success.
If I write:
LIKE '% Alex Maxim%' - null.
I think is from the first white spaces('% Al...').
How can I do this ?
Asked
Active
Viewed 71 times
0
pirho
- 11,565
- 12
- 43
- 70
user3401592
- 29
- 5
-
what are you expecting to get? – John Woo Apr 16 '14 at 06:16
-
check [this](http://stackoverflow.com/questions/10495692/mysql-comparison-operator-spaces) – jomsk1e Apr 16 '14 at 06:31
-
If the first one work, why the second one? – Eric Feb 27 '18 at 21:02
1 Answers
2
Remove whitespaces using TRIM() string function
LIKE CONCAT('%',TRIM(' Alex Maxim'),'%')
If you want to remove only leading whitespace then use LTRIM() function
LIKE CONCAT('%',LTRIM(' Alex Maxim'),'%')
Mudassir Hasan
- 28,083
- 20
- 99
- 133
-
If I use trim I eliminated the all whitespaces.I need just the whitespace before ' Alex Maxim ' – user3401592 Apr 16 '14 at 10:56