With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Course Of The Month
3 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MySql with HP-UX
Posted on 2013-01-02
Hello,
I'm trying to use a simple mysql query using the where option. I looked at a manual that I have and I can't this statement to work. I wonder if there is some setting I am missing.
This statement works; select service from XXXinstances where service='XXX_3';
There are many of each X types. There are X_1, XX_2, and XXXX_4, etc.
I'm trying to use a wide card %, like this;
select service from XXXinstances where service='%_3';
To select all of the _3 types/services.
Why does this not work?
I'm trying to use a simple mysql query using the where option. I looked at a manual that I have and I can't this statement to work. I wonder if there is some setting I am missing.
This statement works; select service from XXXinstances where service='XXX_3';
There are many of each X types. There are X_1, XX_2, and XXXX_4, etc.
I'm trying to use a wide card %, like this;
select service from XXXinstances where service='%_3';
To select all of the _3 types/services.
Why does this not work?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5 Comments
Active today
With a wild card, you need to switch from = to LIKE. Your query should be this:
select service from XXXinstances where service like '%_3';
select service from XXXinstances where service like '%_3';
Active today
Can you try using like instead of =
... where service like '%_3';
edit: after posting I saw the above 2 replies..
... where service like '%_3';
edit: after posting I saw the above 2 replies..
Active today
Even with the LIKE syntax above beware that the '_' is a single character wildcard so it will match 'abcdef3'.
You will need to escape the '_'.
select ... like '%\_3';
http://dev.mysql.com/doc/refman/5.0/en//string-comparison-functions.html
You will need to escape the '_'.
select ... like '%\_3';
http://dev.mysql.com/doc/refman/5.0/en//string-comparison-functions.html
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
- Query Syntax
- SQL
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases, Percona
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month3 days, 9 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.