Menu
I want to join two tables t1 and t2 such that column value in t2 is any valid string including null followed by a value in column of t table.
I want something like :
SELECT * FROM t_cities c JOIN temp_table t ON c.NAME LIKE "%t.token"but don't know the exact sytax. The above statement gives an error of course.
760
The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards often used in conjunction with the LIKE operator: The percent sign (%) represents zero, one, or multiple characters.
To select multiple columns from a table, simply separate the column names with commas! For example, this query selects two columns, name and birthdate , from the people table: SELECT name, birthdate FROM people; Sometimes, you may want to select all columns from a table.
Query: SELECT *, CONCAT(FIRSTNAME, LASTNAME) AS FIRSTNAME FROM demo_table; Output: Here, we can see that FIRSTNAME and LASTNAME is concatenated but there is no space between them, If you want to add space between the FIRSTNAME and LASTNAME then add space(' ') in CONCAT() function.
Try this query, it should work.
SELECT * FROM t_cities as a
JOIN temp_table as b
ON a.NAME LIKE concat("%",b.token);
Note- This query will not going to be fast as normal join and will take time.
174
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
