Top "Sql-like" questions

MySQL starts with searching issue

I'm having an issue using the % wildcard with a MySQL query. http://www.w3schools.com/sql/sql_like.asp …

mysql sql sql-like

Like Case Sensitive in MySQL

I have a MySQL query: SELECT concat_ws(title,description) as concatenated HAVING concatenated LIKE '%SearchTerm%'; And my …

mysql case-sensitive sql-like

SWITCH with LIKE inside SELECT query in MySQL

I have this Tags table CREATE TABLE IF NOT EXISTS `Tags` ( `id_tag` int(10) unsigned NOT NULL auto_increment, `tag` …

sql mysql case switch-statement sql-like

Cannot use a LIKE query in a JDBC PreparedStatement?

The query code and query: ps = conn.prepareStatement("select instance_id, ? from eam_measurement where resource_id in (select RESOURCE_…

java oracle jdbc sql-like

Is there a Hive equivalent of SQL "not like"

While Hive supports positive like queries: ex. select * from table_name where column_name like 'root~%'; Hive Does not …

syntax hive sql-like

How to speed up SELECT .. LIKE queries in MySQL on multiple columns?

I have a MySQL table for which I do very frequent SELECT x, y, z FROM table WHERE x LIKE …

mysql sql-like

How do you force mysql LIKE to be case sensitive?

Possible Duplicate: Mysql Like Case Sensitive Mysql ignores case for its LIKE comparisons. How can you force it to perform …

mysql sql case-sensitive sql-like

Using OR in LIKE Query in MySQL to compare multiple fields

I always thought that you could use OR in a LIKE statment to query things in MySQL. So, if I …

mysql sql-like

How to escape underscore character in PATINDEX pattern argument?

I've found a solution for finding the position of an underscore with PATINDEX : DECLARE @a VARCHAR(10) SET @a = '37_21' …

sql-server regex tsql escaping sql-like

php mysqli prepared statement LIKE

How can I with mysqli make a query with LIKE and get all results? This is my code but it …

php sql mysqli sql-like