Solved

Correct SQL syntax

Posted on 2007-04-07
2
216 Views
Last Modified: 2010-03-19
I need the correct SQL syntax to find any records that contain a certain text.  For example, if table "customers" has a field "address", I would need the syntax to recover any record that has "800" in the address line.  One example result would be the address: 800 Main Street.
0
Comment
Question by:GDTRFBtoo
  • 2
2 Comments
 
LVL 42

Expert Comment

by:dqmq
ID: 18871014
Select * from customers where address like "%800%"
0
 
LVL 42

Accepted Solution

by:
dqmq earned 500 total points
ID: 18871020
Correction:
Select * from customers where address like '%800%'
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video discusses moving either the default database or any database to a new volume.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now