Top "Sql-like" questions

Use LIKE %..% with field values in MySQL

I stumbled into a delicate SQL problem when I needed to use a value from a field inside a LIKE %..% …

mysql sql sql-like

Using LIKE in an Oracle IN clause

I know I can write a query that will return all rows that contain any number of values in a …

sql oracle sql-like

how to use a like with a join in sql?

I have 2 tables, say table A and table B and I want to perform a join, but the matching condition …

mysql sql join sql-like

Using Eloquent ORM in Laravel to perform search of database using LIKE

I want to use Eloquent's active record building to build a search query, but it is going to be a …

orm laravel eloquent sql-like

Is the LIKE operator case-sensitive with MSSQL Server?

In the documentation about the LIKE operator, nothing is told about the case-sensitivity of it. Is it? How to enable/…

sql sql-server-2005 varchar sql-like

Create hive table using "as select" or "like" and also specify delimiter

Is it possible to do a create table <mytable> as select <query statement> using row format …

hive sql-like create-table

Parameter in like clause JPQL

I am trying to write a JPQL query with a like clause: LIKE '%:code%' I would like to …

java jpa eclipselink jpql sql-like

'LIKE ('%this%' OR '%that%') and something=else' not working

I have a select query where I am trying to search strings for multiple patterns LIKE ('%this%' or …

mysql sql sql-like

Using LIKE operator with stored procedure parameters

I have a stored procedure that uses the LIKE operator to search for a truck location among some other parameters @…

sql-server stored-procedures parameters sql-like

SQL Server: use CASE with LIKE

I am pretty new to SQL and hope someone here can help me with this. I have a stored procedure …

sql sql-server stored-procedures case sql-like