mysql like query with special character '

Question

I wrote query for filter data using name and wrote following query

SELECT * FROM (`abc`) WHERE (name LIKE "%test\'!&@#$\%-(3)\_er%")

It should return records which has name start with text "test" but it will not instead of if I modify query like

SELECT * FROM (`abc`) WHERE (name LIKE "%test%\'!&@#$\%-(3)\_er%")

then it will give result. Why it is not give result with first query? Is there any other way to do this?

In your first query `%test` should be changed to `test%` – Jan 10 '14 at 12:39 — , Jan 10 '14 at 12:39

Rick Hoving · Accepted Answer · 2014-01-10T13:31:40.487

5

The % is the wildcard in the query.
So %test means everything that ends with test.
and test% means everything that begins with test.
and %test% means everything with test in it.

Simpy change your query to

SELECT * FROM (abc) WHERE (name LIKE "test%")

edited Jan 10 '14 at 13:31

answered Jan 10 '14 at 12:38

Rick Hoving

3,585
3
29
49

it is not work this SELECT `client_id` FROM (`client`) WHERE (client_name LIKE "%Client@$#%\'!&@#$\%-(3)\_er%") – priyanka patel Jan 10 '14 at 12:44
@priyanka patel SELECT client_id FROM (client) WHERE (client_name LIKE "_____%@$#%\'!&@#$\%-(3)_er%") – GOPI Jan 10 '14 at 12:47

score 0 · Answer 2 · answered Jan 10 '14 at 12:37

0

If you want records that start with test, simply use

SELECT * FROM (`abc`) WHERE (name LIKE "test%")

answered Jan 10 '14 at 12:37

Mad Dog Tannen

7,129
5
31
55

but if user enter any special character in search string then also it should work. – priyanka patel Jan 10 '14 at 12:38
1

It will not return unless that exists if its part of the search query. then you have to filter out the special characters. – Mad Dog Tannen Jan 10 '14 at 12:40

mysql like query with special character '

2 Answers2