• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

MYSQL Query Help

I need to get a SQL Query that I can execute to extract certain data.  Here are the details:

+ DB Type: MySQL
+ DB Name: adminDB
+ Table Name: licenseinfo
+ Field Name: LicenseNumber

So the data in the LicenseNumber Column looks like this: ( this is just a sample there are 300,000 Records)

SSCY-334-0W2-5AA
SSCY -238-2W1-5F9
SSCY -378-0W5-5BD
SSCY -312-061-5PO
SSCF -323-0R2-5FW
SSCF -548-2U1-5OL
SSCF -332-0G5-5BY
SSCF -398-041-5PE

I need to extract all records that have SSCF in the LicenseNumber

I tried query builder in SQLYog but I was getting syntax errors.

Can Someone please write this query for me.

thanks
0
Ishana
Asked:
Ishana
2 Solutions
 
TosterCommented:
Try this

SELECT * FROM licenseinfo WHERE LicenseNumber LIKE '%SSCF%'
0
 
tigin44Commented:
this will give you the records you are looking for


SELECT *
FROM licenseinfo
WHERE LicenseNumber LIKE 'SSCF%'
0
 
jazzIIIloveCommented:
Hi there;

Above comments are true but could you give the error that you have got with SQLYOG so that I can reproduce here in my machine?

Best regards.
0
 
IshanaAuthor Commented:
thanks everyone....got it.!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now