Mysql search query with special character

Question

If i have a variable like

   $volume = 'IV, no. 33';
   $query = "Select post_id FROM wp_postmeta  where meta_value LIKE ".$volume." 

It show error.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' no. 33

So what is the correct way for search with special characte.

You have to put quotes around that string value. `LIKE '".$query->meta_value."'` — Hanky Panky, Jun 10 '13 at 06:22
explain this term "search with special character" with an example. — Rajeev Ranjan, Jun 10 '13 at 06:23
Try: `"Select post_id FROM wp_postmeta where meta_value LIKE "'".$volume."'"` — karthikr, Jun 10 '13 at 06:23
Consider using parametrized queries. http://stackoverflow.com/questions/7869676/parameterized-queries-php-mysql — rkosegi, Jun 10 '13 at 06:33
Take care of SQL-injection, you can do this with parametrized queries (recommended) or with escaping the string input. — martinstoeckli, Jun 10 '13 at 07:23

score 0 · Answer 1 · answered Jun 10 '13 at 06:24

0

You forgot quotes

$query = "Select post_id FROM wp_postmeta  where meta_value LIKE '".$volume."'";

answered Jun 10 '13 at 06:24

Yogesh Suthar

Hanky Panky · Answer 2 · 2013-06-10T06:24:56.513

0

You have to put quotes around your string value

$volume = 'IV, no. 33';
 $query = "Select post_id FROM wp_postmeta  where meta_value LIKE ".$volume."

Should be

$volume = 'IV, no. 33';
$query = "Select post_id FROM wp_postmeta  where meta_value LIKE '".$volume."'";

edited Jun 10 '13 at 06:24

answered Jun 10 '13 at 06:24

Hanky Panky

score 0 · Answer 3 · answered Jun 10 '13 at 06:24

0

Use the below code:

 $volume = 'IV, no. 33';
 $query = "Select post_id FROM wp_postmeta  where meta_value LIKE '".$volume."'";

Use the single quota to tell the query that it is a string.

answered Jun 10 '13 at 06:24

Code Lღver

score 0 · Answer 4 · edited Jun 10 '13 at 07:02

0

Use single quote

LIKE ".$volume."

to

LIKE '".$volume."'

edited Jun 10 '13 at 07:02

Code Lღver

answered Jun 10 '13 at 06:34

Goutam Pal