Top "Sql-like" questions

The LIKE predicate is used to search for a specific pattern in a column.

how to safely generate a SQL LIKE statement using python db-api

I am trying to assemble the following SQL statement using python's db-api: SELECT x FROM myTable WHERE x LIKE 'BEGINNING_…

python sql sql-like python-db-api
MySQL - Is it possible to use LIKE on all columns in a table?

I'm trying to make a simple search bar that searches through my database for certain words. It is possible to …

mysql where sql-like
doctrine2 dql, use setParameter with % wildcard when doing a like comparison

I want to use the parameter place holder - e.g. ?1 - with the % wild cards. that is, something like: "…

doctrine-orm wildcard dql sql-like code-injection
LIKE with % on column names

Here is my query that results in a syntax error: SELECT * FROM account_invoice,sale_order WHERE sale_order.name …

postgresql sql-like
SQL 'LIKE' operator in Hibernate Criteria API

I want to implement some universal filter with Hibernate Criteria. It should work like LIKE operator from SQL: SELECT * FROM …

java hibernate criteria sql-like hibernate-criteria
MySQL like another field

I have a table with two string columns: Url and ModelId. I need to return records for which Url contains …

mysql sql-like
Python SQLite parameter substitution with wildcards in LIKE

I am attempting to use a parametrized LIKE query with Python's Sqlite library as below: self.cursor.execute("select string …

python sqlite sql-like
How to query lucene with "like" operator?

The wildcard * can only be used at the end of a word, like user*. I want to query with a …

java lucene sql-like
SQL Group by "Like"

I have a query where I generate our monthly customer contact activity. We have several categories (email out, email in, …

sql group-by sql-like
How to ignore characters on a MYSQL SELECT LIKE %...%

I have a table with a phone column, where data may have spaces, dots,dashes or + signs between the numbers. …

mysql select wildcard sql-like