SwVitaliy

Untitled

Jul 31st, 2012
34
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. SELECT 'mmp3man+316' LIKE CONCAT( s.prefix, p.pattern_delim, '%' ) , CONCAT( s.prefix, p.pattern_delim, '%' )
  2. FROM `sms_subscription` AS s
  3. LEFT JOIN `project` AS p ON p.`id` = s.`project_id` # where 'mmp3man+316' like CONCAT(s.prefix, p.pattern_delim, '%')
  4.  
  5. LIMIT 0 , 30
Advertisement
Add Comment
Please, Sign In to add comment