I have a string like this 67,73,89. I want to explode all the value and compare each value. In php  I can do it like this  &lt;?php $marks = "67, 73, 89"; $explode = explode(", ",$marks); foreach($explode as $mark){     if($mark &gt; 80)     echo $mark."&lt;br&gt;"; } ?&gt;   Can anyone give me the mysql code so that i can select all the student roll number where marks contains atleast one value > 80. You can use mysql explode function like this...  CREATE FUNCTION explode(str VARCHAR(255), delim VARCHAR(12), pos INT) RETURNS VARCHAR(255) RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(str, delim, pos),        LENGTH(SUBSTRING_INDEX(str, delim, pos-1)) + 1),        delim, '');   Table structure is  ╔═════════╦═══════╦══════════╗ ║ Roll_No ║ Name  ║  Marks   ║ ╠═════════╬═══════╬══════════╣ ║       1 ║ John  ║ 67,73,89 ║ ║       2 ║ Bob   ║ 75,69,80 ║ ║       3 ║ Smith ║ 62,79,92 ║ ╚═════════╩═══════╩══════════╝
I have to create a report on some student completions. The students each belong to one client. Here are the tables (simplified for this question).  CREATE TABLE  `clients` (   `clientId` int(10) unsigned NOT NULL auto_increment,   `clientName` varchar(100) NOT NULL default '',   `courseNames` varchar(255) NOT NULL default '' )   The courseNames field holds a comma-delimited string of course names, eg "AB01,AB02,AB03"  CREATE TABLE  `clientenrols` (   `clientEnrolId` int(10) unsigned NOT NULL auto_increment,   `studentId` int(10) unsigned NOT NULL default '0',   `courseId` tinyint(3) unsigned NOT NULL default '0' )   The courseId field here is the index of the course name in the clients.courseNames field. So, if the client's courseNames are "AB01,AB02,AB03", and the courseId of the enrolment is 2, then the student is in AB03.  Is there a way that I can do a single select on these tables that includes the course name? Keep in mind that there will be students from different clients (and hence have different course names, not all of which are sequential,eg: "NW01,NW03")  Basically, if I could split that field and return a single element from the resulting array, that would be what I'm looking for. Here's what I mean in magical pseudocode:  SELECT e.`studentId`, SPLIT(",", c.`courseNames`)[e.`courseId`] FROM ...
Is there a way of moving unwanted villagers out faster? Remove Personal Options section from Profile I want to hide/remove the Personal Options in the Your Profile (wp-admin/profile.php) admin page.  I am aware that solutions for this exist, but I they use jQuery to do hide this section. This works, but when a user has JavaScript disabled in their browser, it will show up again. Therefore it is not a proper way to remove Personal Options.  Is there a way to remove the Personal Options section from the HTML source of the page? This means no jQuery or CSS hacks, or core file modification. SOAP or REST for Web Services? How to visualize the gradient as a one-form? I am reading Sean Carrol's book on General Relativity, and I just finished reading the proof that the gradient is a covariant vector or a one-form, but I am having a difficult time visualizing this. I usually visualize gradients as vector fields while I visualize one-forms with level sets. How to visualize the gradient as a one-form? Can a finite group act freely (as homeomorphisms) on $\mathbb R^n$ I am asking if whether or not a finite group acts freely (as homeomorphisms) on $\mathbb R^n$.  To answer in the negative, it suffices to show: for any homeomorphism $f$ such that $f^d=\text{id}_{\mathbb R^n}$, then $f$ has a fixed point.  I am looking for a complete self-contained answer. How do I calculate the power consumed by a lightbulb? How to open a PDF file from terminal? I used to work on the Mac terminal before and I used:   open file2open.pdf   and the PDF file would be opened on preview or whatever my default viewer was. When I use it in the terminal in Ubuntu I get this error message:   Couldn't get a file descriptor referring to the console ffmpeg - Create a video from image frame with a start and a count How do I install Chromium from the command line? I have already tried using the Ubuntu Software Center, but it won't install the Chromium browser. How can I install it using the terminal? I was using the amspset document class for generating exam practice problems. I had wanted to add some referencing to the problems so I started a new counter like this (adapted from some Tex Exchange post)  \newcounter{P} \newcommand{\plb}[1]{\refstepcounter{P}\label{#1} \textbf{P-\ref{#1}.}}  \begin{problem} \plb{p1} A parallel-wire transmission line is constructed of \#6 AWG copper wire (diameter $d=0.162$ in., conductivity $\sigma_c=5.8\times 10^7$ S/m) with a 12-inch separation in air. Assuming no leakage between the two wires, find $R'$, $L'$, $G'$, and $C'$. Assume a working frequency of 1 MHz. \end{problem}  \begin{solution} Using Table.~\ref{tab:tlparam} and Fig.~\ref{fig:tlempl},  \[ Rs = \sqrt{\pi f \mu_c/\sigma_c} = 2.61\times10^{-4}~ \Omega\] \[ R' = \frac{2R_s}{\pi d} = 4.04\times10^{-2} ~\Omega\text{/m} \] \[ L' = \frac{\mu_0}{\pi} \ln{\frac{2D}{d}}=2.0~\mu \text{H/m} \] \[ C' = \frac{\pi \epsilon}{\displaystyle\ln{\frac{2D}{d}}}=5.56 ~\text{pF/m} \] $G'=0$ because the problem states that there is no leakage between the two wires. \end{solution}  \begin{figure}[ht] \begin{centering}     \includegraphics{fig24}     \caption{(Fig.2-4 from FAE) A few examples of transmission lines.} \end{centering} \label{fig:tlempl} \end{figure}  \begin{table}[ht] \caption{(Table 2-1 from FAE)Transmission-line parameters $R'$, $L'$, $G'$, and $C'$ for three types of lines.}     \begin{tabular}{c}         \hspace{3cm}\includegraphics{tb21}     \end{tabular} \label{tab:tlparam} \end{table} ... and more   Now all the figure references stop working, I get "Fig. " instead of "Fig. 1". The table references are alright though. Any idea what the problem could be? Why is it “a defeated Napoleon, not “the defeated Napoleon” who rode off the battlefield and into exile? I noticed an infinite article; ‘a’ was used before ‘defeated Napoleon’ in the following sentence of Jeffery Archer’s novel, "Fales Impression" :  “General Sir Harry Wentworth sat at the right hand of the Iron Duke that night, and was commanding his left flank when a defeated Napoleon rode off the battlefield and into exile."  I’m curious to know why it should be “a defeated Napoleon,” not “the defeated Napoleon” or simply “defeated Napoleon.” Isn’t it only one Napoleon who was defeated the battle and exiled (to St. Helena). It looks like as though there were many (defeated) Napoleons who were exiled.  It’s always headache for me to handle articles as we Japanese (I think Chinese too) don’t have article as the basic part of speeches in our language system. I’ve studied it on English grammar text books at school, but have never reached full understanding of the usage of articles, because we don’t have that practice. Is there any special knack to master how to use articles? In history we are taught that the Catholic Church was wrong, because the Sun does not move around the Earth, instead the Earth moves around the Sun.  But then in physics we learn that movement is relative, and it depends on the reference point that we choose.  Wouldn't the Sun (and the whole universe) move around the Earth if I place my reference point on Earth?  Was movement considered absolute in physics back then? BAV99 forward voltage I am reading the  From the table on ELECTRICAL CHARACTERISTICS (page 2) (TA = 25°C unless otherwise noted) (Each Diode)     Forward Voltage mVdc     IF = 1 mAdc 715mV   IF = 10 mAdc 855mV   IF = 50 mAdc 1.0V   IF = 150 mAdc 1.25V     On page 3 there is the following VI curve graph:  Clearly at 25°C - 100mA is Vf = 0.9V. There is huge difference between the table and the IV curve.  Which source of information I should trust? Is this (typical) and (maximum) where the table guarantees the diode won't exceed Vf 1.0v at 50mA while the graph is just typical values? Does a size large or larger creature killed by Negative Energy Flood rise as a medium sized zombie? How to prove this sequent using natural deduction? How do I prove $$S\rightarrow \exists xP(x) \vdash \exists x(S\rightarrow P(x))$$ using natural deduction? Just an alignment of which axioms or rules that one could use would be much appreciated. I found  where a technician with a lot of experience seems to clean his PCBs using water, and then he just puts it in the sun so it can dry. I was just amazed to see the circuit keeps working as intended, he says he keeps doing this all the time and several times, however I doubt this is normal.  Which leave me some questions:   What are the recommended methods to clean huge PCBs like the one in the video? What happens to charged capacitors when water shorts them out? Solder joints do not get any kind of corrosion? Is the antisolder mask waterproof? Create alphabetical pager Object appears smoothed after rendering but not in viewport What font is used in this image? How do they film the mirror scenes in movies?