SQL with LIKE
Posted: Mon Dec 01, 2008 10:21 pm
Hi all,
I am developing a php application which needs use of SQL. In SQL query I have to use 'LIKE' construct.
Currently my query is like
$select->from(array('m' => 'mail_delivery'),
array('mail_subject', 'delivery_date'))
->join(array('u' =>' user'),
'm.delivery_user_id = u.id',
array('id','user_name'))
->where("m.mail_subject like '%?%'", $criteria['mail_subject'],
'u.user_name like \'%?%\'", $criteria['delivery_user_name']);
I am getting syntax error near like. Can anybody tell me what is correct syntax to use like construct.
Thanks in advance.
I am developing a php application which needs use of SQL. In SQL query I have to use 'LIKE' construct.
Currently my query is like
$select->from(array('m' => 'mail_delivery'),
array('mail_subject', 'delivery_date'))
->join(array('u' =>' user'),
'm.delivery_user_id = u.id',
array('id','user_name'))
->where("m.mail_subject like '%?%'", $criteria['mail_subject'],
'u.user_name like \'%?%\'", $criteria['delivery_user_name']);
I am getting syntax error near like. Can anybody tell me what is correct syntax to use like construct.
Thanks in advance.