A database application I've written uses a table with around 600,000 rows. Each row has a text field 500-5000 characters long. I periodically need to find all the rows containing a particular phone number, name, or address, ie.'123-4567', 'john smith', '1950 Main St N ( Read more... )

I've struggled with this for a few days now and thought some of you may have insight ( Read more... )

Anyone know how to store a MySQL database schema (and maybe data from some tables hopefully based on table structure) into SVN?

I found an instruction set that said to list the first, and last name of all employees that had neither 'SON' nor 'DAUGHTER' listed in their dependency files. I came up with a query that gave me the results I wanted by assuming the database only takes SPOUSE, SON, and DAUGHTER, but assuming has always caused me trouble, so I would like to know: Is ( Read more... )

i have this thing on another page it works but its like the same and doesnt work on the page im working on. this is what it is:
SELECT column, column2 FROM table
doesnt work. only shows column one. ive done all the variations i can think of SELECT `column1`, `column2` ectttt fucking ect does anyone know why this is o pathetic and will NOT WORK?

I am not entirely sure if this is the right place to ask but I thought to give it a shot anyway ( Read more... )

hey again ( Read more... )

I have some difficulties in building a right query for a situation. A MySQL Table 'patients' looks like this ( Read more... )

i have a field with a full street address, something like "1234 main st." is it possible to select just the numerical part of the data?

i ask because i need to compare that to another field. so it'd be real easy to just do something like

select * from `table` where (MAGIC, `address`) = `other_field`