DB Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

SELECT * FROM `user` the_table WHERE the_table.userid = DB Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

SELECT * FROM `user` the_table WHERE the_table.userid = In UNIX/LINUX, how can I find words that contain only the letters of my first - iTechForums
Login
Search   Moderators Wanted: If you're interested please send your portfolio to info[at]itechforums.com
Welcome to the iTechForums.
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
To register now click here.
Latest Threads
Advertisements
Forum Statistics
Threads:
Posts: 2
Members:
Number of Users Online:
Welcome to our newest member,
Reply
 
Thread Tools Display Modes
  #1  
Old 03-09-2010, 04:24 PM
Zatara Zatara is offline
Junior Member
 
Join Date: Mar 2010
Posts: 2
Default

In UNIX/LINUX, how can I find words that contain only the letters of my first


In UNIX/LINUX, how can I find words that contain only the letters of my first

name using grip command ? I tried this, but it didn't work!!
grep '.*a.*' dictionary.txt

Please help...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

  #2  
Old 03-09-2010, 04:24 PM
Namibnat Namibnat is offline
Junior Member
 
Join Date: Sep 2009
Posts: 17
Default

...first name using grip command? I am assuming you mean 'grep' command, since that is what you started working with below. (Grip is a CD ripper or something like that.)

grep -owi '[a-z]*[veron][a-z]*' dictionary.txt

The -o lets you return only the match, not the whole line
The -w helps you only find matches for a word, this makes it easier to write the regex
The -i lets you ignore case

You can put them together -owi

Then, instead of searching for '.*' which searches for any character at all (remember, this includes ALL characters, like new-line (which is a single Ascii character) and spaces and numbers. I assume you only want words...made of alphabetical letters...and so start and end with [a-z]*
For your name, you want to look for any of the characters, if they occur at least once, and so you can just put [theCharactersOfYourName] in brackets. It doesn't matter if there are more, they will be picked up by the 'any number of characters' before and after.

Edit - my name is vernon, which is why I searched with 'veron', not needing both the n letters.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
In UNIX/LINUX, I am trying to use the grip command to find words with MAQ UNIX 0 03-08-2010 09:11 AM
Hi, I'm trying to find perfect key words for a fashion website domain charith5000 Domain Names 0 12-04-2009 03:54 PM
How do I write a script in Unix that counts how many different words are there in a Darren L UNIX 0 05-01-2009 02:56 PM
Where can I find 'Terminal' to run Linux/Unix? mojo jojo UNIX 0 11-08-2008 06:49 AM
want to find internet service or dictionary that gives related words... amit_campbel Java, Java Servlets & JSP 0 06-18-2008 11:57 AM

Your Ad Here

All times are GMT. The time now is 03:49 AM.