Top "Sql-like" questions

How do I find ' % ' with the LIKE operator in SQL Server?

I have a column name Address which consists of some address which has '%' in between as: Address -------------------- …

sql-server tsql sql-like

What is the best way to search the Long datatype within an Oracle database?

I am working with an Oracle database that stores HTML as a Long datatype. I would like to query the …

sql oracle sql-like ora-00932

MySQL - How to search for exact word match using LIKE?

I'm using this query to select data: mysql_query("SELECT * FROM products WHERE product_name LIKE '%".$search."%'"); The …

mysql select sql-like

SQLite Like % and _

I can't figure out what the underscore character does in an SQLite like statement. The wildcard character, %, is probably the …

sql sqlite sql-like

PostgreSQL LIKE query performance variations

I have been seeing quite a large variation in response times regarding LIKE queries to a particular table in my …

postgresql indexing pattern-matching query-optimization sql-like

Element or class LIKE selector for jQuery?

For whatever reason I have these classes called .main_sub1, .main_sub2 etc. Never mind why I can't have .main .…

jquery jquery-selectors sql-like

Regular expression to match start of filename and filename extension

What is the regular expression to match strings (in this case, file names) that start with 'Run' and have a …

python sql regex sql-like

Hibernate HQL query by using like operator

Seu the following mapping @Entity public class User { private Integer id; @Id; private Integer getId() { return this.id; } } Notice id …

hibernate hql sql-like

How to retrieve rows that begin and end with specific characters?

I have one table called STUDENT. In this table there are two columns, ID and NAME. I want to retrieve …

sql select sql-like

"Like" operator in inner join in SQL

Using Sequel Pro, I have these two tables: Table1 Name Year x y John Smith 2010 10 12 Adam Jones 2010 8 13 John Smith 2011 7 15 Adam …

sql join sql-like