dziabaa — 2012-11-11T13:48:09-05:00 — #1
I would like to ask for help. I do not know how to write a query to a database that records marked I like the file shown http://www.panorama.vot.pl/table.jpg. I want to search for a string of records in col1 from col2 (highlight it wants and how it does not find that the lack of communication drew within. Number of records in col2 will increase or decrease. Thanks in advance for any answers.
kylewolfe — 2012-11-14T15:18:04-05:00 — #2
Please paste your table structure on here in plain text so that everyone can read it in case you take that image down, plus I don't want to open that while at work.
dziabaa — 2012-11-14T16:04:43-05:00 — #3
I want to search for a string of records in col1 from col2 (highlight it wants and how it does not find that the lack of communication drew within. Number of records in col2 will increase or decrease. Thanks in advance for any answers.
kylewolfe — 2012-11-14T16:15:27-05:00 — #4
So there is no "highlighting" in SQL. I'm also at a loss when trying to figure out what you want your final result to be out of that recordset.
dziabaa — 2012-12-01T12:27:27-05:00 — #5
I want find records from col2 in the same order in col1 . You can see that on picture http://www.panorama.vot.pl/table.jpg
kylewolfe — 2012-12-01T13:39:33-05:00 — #6
So you want your end result to be
dziabaa — 2012-12-01T14:20:03-05:00 — #7
yes, and will it possible in which id (of course if I have id column)
dziabaa — 2012-12-04T14:10:18-05:00 — #8
So what is your query for
kylewolfe — 2012-12-04T14:13:30-05:00 — #9
I don't have one yet. Not sure I've seen one like this before. What sql server are you using? Also how large of a table are we talking about?
dziabaa — 2012-12-04T14:30:28-05:00 — #10
I'm usigng MySQL server and table have one column with 2000 records and second column with flexible records (5-10).
r937 — 2012-12-04T15:51:42-05:00 — #11
I'm usigng MySQL server
could you please run this query and post the results --
SHOW CREATE TABLE [I]tablename[/I]
where tablename is the name of your table
dziabaa — 2012-12-04T15:59:18-05:00 — #12
id int(50) NOT NULL AUTO_INCREMENT,
col1 varchar(50) CHARACTER SET latin2 NOT NULL,
col2 varchar(50) CHARACTER SET latin2 NOT NULL,
PRIMARY KEY (
) ENGINE=MyISAM AUTO_INCREMENT=100 DEFAULT CHARSET=utf8
r937 — 2012-12-04T17:30:43-05:00 — #13
i do not understand this
r937 — 2012-12-04T17:31:30-05:00 — #14
i don't understand this, either