Skip to content

Instantly share code, notes, and snippets.

@alokstha1
Created August 27, 2015 09:09
Show Gist options
  • Save alokstha1/59c7ac3516c2a6dd8ab5 to your computer and use it in GitHub Desktop.
Save alokstha1/59c7ac3516c2a6dd8ab5 to your computer and use it in GitHub Desktop.
Select sql from two table LIKE on first table
SELECT * from table1 as t1 LEFT JOIN table2 as t2 ON t2.foreign_key = t1.prmary_key WHERE t1.column_name LIKE '%{variable}%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment